USE [AnotherSuccessfulProcedure]

IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[CaptureBlocksInsert]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
BEGIN
	DROP PROCEDURE dbo.CaptureBlocksInsert
END


SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Neil Wilson
-- Create date: 08/29/08
-- Description:	CaptureBlocks Table Insert
-- =============================================
CREATE PROCEDURE CaptureBlocksInsert

	@CaptureBlockId int,
	@CaptureBlockTime datetime,
	@CapNumber int,
	@CapName varchar(30),
	@LogId int,
	@RoundId int,
	@MiniRoundId int,
	@MapId int,
	@PlayerId varchar(30)
	

AS
BEGIN

	INSERT INTO [CaptureBlocks] (	
			CaptureBlockId ,
			CaptureBlockTime,
			CapNumber,
			CapName ,
			LogId ,
			RoundId ,
			MiniRoundId ,
			MapId ,
			PlayerId 
		  )
	VALUES(	
			@CaptureBlockId ,
			@CaptureBlockTime,
			@CapNumber,
			@CapName ,
			@LogId ,
			@RoundId ,
			@MiniRoundId ,
			@MapId ,
			@PlayerId 
		  )

END
GO

